この分析モデルは次の目的で使用されます:メンテナンス。Power BI の一部として予めパッケージ化され、提供される分析モデルのリストがあります。リストは、こちらを参照してください。
主な分析シナリオは次のとおりです。
| モデル テーブル | BI アクセスビュー | 参照情報ソース | 推奨アクセスタイプ |
| FACT TIME | DIM_BI_TIME_BI | DIM_BI_TIME | オンライン |
| WORK TASK POSTINGS | FACT_JT_TASK_ACCT_PQ_BI | FACT_JT_TASK_ACCT_PQ | オンライン |
| WO BUDGET | FACT_WO_BUDGET_PQ_BI | FACT_WO_BUDGET_PQ | オンライン |
| WORK TASK ACTUALS SALES | FACT_WO_TASK_ACT_SALES_PQ_BI | FACT_WO_TASK_ACT_SALES_PQ | オンライン |
| FACT WORK ORDER | FACT_WORK_ORDER_PQ_BI | FACT_WORK_ORDER_PQ | オンライン |
| WORK TASK ACTUALS COST | FACT_WORK_TASK_ACT_COST_PQ_BI | FACT_WORK_TASK_ACT_COST_PQ | オンライン |
| WORK TASK PLANNED | FACT_WORK_TASK_PLANNED_PQ_BI | FACT_WORK_TASK_PLANNED_PQ | オンライン |
| FACT WORK TASK | FACT_WORK_TASK_PQ_BI | FACT_WORK_TASK_PQ | オンライン |
| ASSET HEALTH MEASURES | FACT_ASSET_HEALTH_BI | FACT_ASSET_HEALTH | オンライン |
| CURRENCY RATES | FACT_CURRENCY_RATES_PQ_BI | FACT_CURRENCY_RATES_PQ | オンライン |
対応する情報ソースについては以下に記載しています。情報ソースに関する詳しい情報は、情報ソースについてをご覧ください。
FACT_WO_TASK_ACTUALS_SALES
作業オーダの実際の売上情報ソースは、作業タスクに関連する収益に基づいています。この情報ソースには、時間のレポート、材料の問題、ツールの使用、収益額などの費用に関するトランザクションが含まれます。
FACT_WORK_TASK_ACTUALS_COST
作業タスクの実際のコスト情報ソースは、作業タスクに関連するコストに基づいています。この情報ソースには、経費、外部、固定価格、材料、人員、ツール/機器のトランザクションが含まれます。
FACT_WO_BUDGET
作業オーダの予算情報ソースは、作業オーダー書に手入力した予算コストと収益に基づいています。分析には主に作業オーダの実績の情報ソースと組み合わせて使用する必要があります。
FACT_WORK_TASK_PLANNED
作業のタスク計画に関する情報ソースは、作業タスクの計画ラインに基づいています。分析には主に作業タスクの実際の情報ソースと組み合わせて使用する必要があります。
FACT_WORK_ORDERS
作業オーダの情報ソースは 「IFS\作業オーダ」に基づいています。この情報ソースには、すべてのステータスの作業オーダ (アクティブな作業オーダと履歴作業オーダの両方)、および作業要求と障害レポートが含まれます。
FACT_WORK_TASK
作業オーダー書には、1 つ以上の作業タスクを接続できます。作業タスクは、障害レポートやサービス要求などによって開始された作業を実行するエンティティです。IFS/サービス管理を使用することで、実行されたメンテナンス アクティビティが作業タスクを通じて顧客に報告、監視、請求できます。
FACT_JT_TASK_ACCOUNTING
作業タスク会計情報ソースは、作業タスクに関連する実際のトランザクションに基づいています。作業オーダ、作業タスク、作業タスクのトランザクション、作業タスク コストのデータを組み合わせます。
| モデル テーブル | BI アクセスビュー | 参照情報ソース | 推奨アクセスタイプ |
| ACCOUNT | DIM_ACCOUNT_BI | DIM_ACCOUNT | オンライン |
| ACTIVITY | DIM_ACTIVITY_BI | DIM_ACTIVITY | オンライン |
| CAUSE | DIM_CAUSE_BI | DIM_CAUSE | オンライン |
| CLASS | DIM_CLASS_BI | DIM_CLASS | オンライン |
| CANCEL TASK CAUSE | DIM_CANCEL_TASK_CAUSE_BI | DIM_CANCEL_TASK_CAUSE | オンライン |
| CODE B | DIM_CODE_B_BI | DIM_CODE_B | オンライン |
| CODE C | DIM_CODE_C_BI | DIM_CODE_C | オンライン |
| CODE D | DIM_CODE_D_BI | DIM_CODE_D | オンライン |
| CODE E | DIM_CODE_E_BI | DIM_CODE_E | オンライン |
| CODE F | DIM_CODE_F_BI | DIM_CODE_F | オンライン |
| CODE G | DIM_CODE_G_BI | DIM_CODE_G | オンライン |
| CODE H | DIM_CODE_H_BI | DIM_CODE_H | オンライン |
| CODE I | DIM_CODE_I_BI | DIM_CODE_I | オンライン |
| CODE J | DIM_CODE_J_BI | DIM_CODE_J | オンライン |
| COMPANY | DIM_COMPANY_BI | DIM_COMPANY | オンライン |
| COMPATIBLE UNIT | DIM_CMPUNT_COMPATIBLE_UNIT_BI | DIM_CMPUNT_COMPATIBLE_UNIT | オンライン |
| CUSTOMER | DIM_CUSTOMER_BI | DIM_CUSTOMER | オンライン |
| DISCOVERY | DIM_DISCOVERY_BI | DIM_DISCOVERY | オンライン |
| EVENT | DIM_EVENT_BI | DIM_EVENT | オンライン |
| FAILING COMPONENT | DIM_FAILING_COMPONENT_BI | DIM_FAILING_COMPONENT | オンライン |
| FAULT TYPE | DIM_FAULT_TYPE_BI | DIM_FAULT_TYPE | オンライン |
| ITEM CLASS FUNCTION | DIM_ITEM_CLASS_FUNCTION_BI | DIM_ITEM_CLASS_FUNCTION | オンライン |
| ITEM CLASS SOURCE | DIM_IC_SOURCE_TYPE_BI | DIM_IC_SOURCE_TYPE | オンライン |
| LINEAR ASSET | DIM_LINAST_LINEAR_ASSET_PQ_BI | DIM_LINAST_LINEAR_ASSET_PQ | オンライン |
| OPERATIONAL STATUS | DIM_OPERATIONAL_STATUS_BI | DIM_OPERATIONAL_STATUS | オンライン |
| ORGANIZATION | DIM_ORGANIZATION_BI | DIM_ORGANIZATION | オンライン |
| PERFORMED ACTION | DIM_PERFORMED_ACTION_BI | DIM_PERFORMED_ACTION | オンライン |
| PM GROUP | DIM_PM_GROUP_BI | DIM_PM_GROUP | オンライン |
| PRIORITY | DIM_PRIORITY_BI | DIM_PRIORITY | オンライン |
| PROJECT | DIM_PROJECT_BI | DIM_PROJECT | オンライン |
| PROJECT PROGRAM | DIM_PROJECT_PROGRAM_BI | DIM_PROJECT_PROGRAM | オンライン |
| REPORTING CURRENCY | FACT_CURRENCY_RATES_BI,LUP_REP_CURR_RATE_TYPE_TC,DIM_CURRENCY_CODE_BI,DIM_CURRENCY_RATE_TYPE_BI | DIM_REPORTING_CURRENCY | オンライン |
| REPORTING PERIOD | DIM_REPORTING_PERIOD_PQ_BI | DIM_REPORTING_PERIOD_PQ | オンライン |
| SALES PART | DIM_SALES_PART_BI | DIM_SALES_PART | オンライン |
| SERVICE CONTRACT | DIM_SERVICE_CONTRACT_LINE_BI | DIM_SERVICE_CONTRACT_LINE | オンライン |
| SITE | DIM_SITE_BI | DIM_SITE | オンライン |
| SLA ORDER | DIM_SLA_ORDER_BI | DIM_SLA_ORDER | オンライン |
| SLA ORDER LINE | DIM_SLA_ORDER_LINE_BI | DIM_SLA_ORDER_LINE | オンライン |
| SOURCE CONNECTION | DIM_JT_CONNECTED_OBJECT_BI | DIM_JT_CONNECTED_OBJECT | オンライン |
| SOURCE OBJECT | DIM_SOURCE_OBJECT_BI | DIM_SOURCE_OBJECT | オンライン |
| SUPPLIER | DIM_SUPPLIER_BI | DIM_SUPPLIER | オンライン |
| SYMPTOM | DIM_SYMPTOM_BI | DIM_SYMPTOM | オンライン |
| TASK ACCOUNTING TYPE | DIM_TASK_ACCOUNTING_TYPE_BI | DIM_TASK_ACCOUNTING_TYPE | オンライン |
| TIME TYPE | DIM_TIME_TYPE_BI | DIM_TIME_TYPE | オンライン |
| TRANSACTION TYPE | DIM_TRANSACTION_TYPE_BI | DIM_TRANSACTION_TYPE | オンライン |
| VIM SERIAL | DIM_VIM_SERIAL_BI | DIM_VIM_SERIAL | オンライン |
| WO CONNECTION TYPE | DIM_WO_CONNECTION_TYPE_BI | DIM_WO_CONNECTION_TYPE | オンライン |
| WORK ORDER | DIM_WORK_ORDER_BI | DIM_WORK_ORDER | オンライン |
| WORK STAGE | DIM_WORK_STAGE_BI | DIM_WORK_STAGE | オンライン |
| WORK TASK | DIM_WORK_TASK_BI | DIM_WORK_TASK | オンライン |
| WORK TYPE | DIM_WORK_TYPE_BI | DIM_WORK_TYPE | オンライン |
| WORK TYPE CATEGORY | DIM_WORK_TYPE_CATEGORY_BI | DIM_WORK_TYPE_CATEGORY | オンライン |
| CRITICALITY | DIM_CRITICALITY_BI | DIM_CRITICALITY | オンライン |
| WO COST TYPE | DIM_WO_COST_TYPE_BI | DIM_WO_COST_TYPE | オンライン |
| ITEM CLASS | DIM_ITEM_CLASS_PQ_BI | DIM_ITEM_CLASS_PQ | オンライン |
| REPORTING DATE | DIM_BI_TIME_BI | DIM_BI_TIME | オンライン |
| SUB PROJECT | DIM_SUB_PROJECT_PQ_BI | DIM_SUB_PROJECT_PQ | オンライン |
| WT CONNECTION TYPE REPORTED | DIM_WO_CONNECTION_TYPE_BI | DIM_WO_CONNECTION_TYPE | オンライン |
| WT CONNECTION TYPE ACTUAL | DIM_WO_CONNECTION_TYPE_BI | DIM_WO_CONNECTION_TYPE | オンライン |
| 伝票日付 | DIM_BI_TIME_BI | DIM_BI_TIME | オンライン |
| SOURCE SITE | DIM_SITE_BI | DIM_SITE | オンライン |
| SLA 最終開始日 | DIM_BI_TIME_BI | DIM_BI_TIME | オンライン |
| SLA 最終終了日 | DIM_BI_TIME_BI | DIM_BI_TIME | オンライン |
| 必須開始日 | DIM_BI_TIME_BI | DIM_BI_TIME | オンライン |
| 必須終了日 | DIM_BI_TIME_BI | DIM_BI_TIME | オンライン |
| REPORTED OBJECT SITE | DIM_SITE_BI | DIM_SITE | オンライン |
| PLANNED START DATE | DIM_BI_TIME_BI | DIM_BI_TIME | オンライン |
| 計画終了日 | DIM_BI_TIME_BI | DIM_BI_TIME | オンライン |
| 計画日 | DIM_BI_TIME_BI | DIM_BI_TIME | オンライン |
| ORGANIZATION SITE | DIM_SITE_BI | DIM_SITE | オンライン |
| CREATED DATE | DIM_BI_TIME_BI | DIM_BI_TIME | オンライン |
| ACTUAL START DATE | DIM_BI_TIME_BI | DIM_BI_TIME | オンライン |
| ACTUAL OBJECT SITE | DIM_SITE_BI | DIM_SITE | オンライン |
| ACTUAL FINISH DATE | DIM_BI_TIME_BI | DIM_BI_TIME | オンライン |
| ACTUAL EQUIPMENT OBJECT | DIM_EQUIPMENT_OBJECT_PQ_BI | DIM_EQUIPMENT_OBJECT_PQ | オンライン |
| REPORTED EQUIPMENT OBJECT | DIM_EQUIPMENT_OBJECT_BI | DIM_EQUIPMENT_OBJECT | オンライン |
| ASSET TYPE | DIM_ASSET_TYPE_BI | DIM_ASSET_TYPE | オンライン |
| ASSET HEALTH HISTORY | FACT_ASSET_HEALTH_HISTORY_BI | FACT_ASSET_HEALTH_HISTORY | オンライン |
| ASSET HEALTH INDI HST | FACT_ASSET_HEALTH_INDI_HST_BI | FACT_ASSET_HEALTH_INDI_HST | オンライン |
| ASSET HEALTH INDICATOR | FACT_ASSET_HEALTH_INDICATOR_BI | FACT_ASSET_HEALTH_INDICATOR | オンライン |
| ASSET HEALTH LEVEL | FACT_ASSET_HEALTH_LEVEL_BI | FACT_ASSET_HEALTH_LEVEL | オンライン |
| ASSET HEALTH | FACT_ASSET_HEALTH_BI | FACT_ASSET_HEALTH | オンライン |
| ASSET HEALTH DIMENSION | DIM_ASSET_HEALTH_BI | DIM_ASSET_HEALTH | オンライン |
| ASSET HEALTH INDICATOR DIMENSION | DIM_ASSET_HEALTH_INDICATOR_BI | DIM_ASSET_HEALTH_INDICATOR | オンライン |
| COLOR LEVEL | 該当なし | EAM_COLOR_LEVEL | オンライン |
| EnvPath | 該当なし | EAM_ENVIRONMENT_PATH | オンライン |
| HEALTH LEVEL | 該当なし | EAM_HEALTH_LEVEL | オンライン |
| 場所 | 該当なし | 該当なし |
次の表は、モデル内のテーブルと列の関係を示しています。
| 関係:テーブル (列) - テーブル (列) |
| CURRENCY RATES (DIM_REPORTING_CURRENCY_ID) - REPORTING CURRENCY (ID) |
| CURRENCY RATES (DIM_TIME_ID) - REPORTING DATE (ID) |
| FACT TIME (ID) - ACTUAL FINISH DATE (ID) |
| FACT TIME (ID) - ACTUAL START DATE (ID) |
| FACT TIME (ID) - CREATED DATE (ID) |
| FACT TIME (ID) - PLANNED DATE (ID) |
| FACT TIME (ID) - PLANNED FINISH DATE (ID) |
| FACT TIME (ID) - PLANNED START DATE (ID) |
| FACT TIME (ID) - REPORTING DATE (ID) |
| FACT TIME (ID) - REQUIRED FINISH DATE (ID) |
| FACT TIME (ID) - REQUIRED START DATE (ID) |
| FACT TIME (ID) - SLA LATEST FINISH DATE (ID) |
| FACT TIME (ID) - SLA LATEST START DATE (ID) |
| FACT TIME (ID) - VOUCHER DATE (ID) |
| FACT WORK ORDER (Dim_Activity_ID) - ACTIVITY (ID) |
| FACT WORK ORDER (DIM_COMPANY_ID) - COMPANY (ID) |
| FACT WORK ORDER (Dim_Compatible_Unit_ID) - COMPATIBLE UNIT (ID) |
| FACT WORK ORDER (Dim_Customer_ID) - CUSTOMER (ID) |
| FACT WORK ORDER (Dim_Date_Actual_Complete_ID) - ACTUAL FINISH DATE (ID) |
| FACT WORK ORDER (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID) |
| FACT WORK ORDER (Dim_Date_Created_ID) - CREATED DATE (ID) |
| FACT WORK ORDER (Dim_Date_Planned_Complete_ID) - PLANNED FINISH DATE (ID) |
| FACT WORK ORDER (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID) |
| FACT WORK ORDER (Dim_Date_Required_Complete_ID) - REQUIRED FINISH DATE (ID) |
| FACT WORK ORDER (Dim_Date_Required_Start_ID) - REQUIRED START DATE (ID) |
| FACT WORK ORDER (Dim_Discovery_ID) - DISCOVERY (ID) |
| FACT WORK ORDER (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID) |
| FACT WORK ORDER (Dim_Equipment_Object_ID) - REPORTED EQUIPMENT OBJECT (ID) |
| FACT WORK ORDER (Dim_Event_ID) - EVENT (ID) |
| FACT WORK ORDER (Dim_Linear_Asset_ID) - LINEAR ASSET (ID) |
| FACT WORK ORDER (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| FACT WORK ORDER (DIM_ORGANIZATION_ID) - ORGANIZATION (ID) |
| FACT WORK ORDER (Dim_Priority_ID) - PRIORITY (ID) |
| FACT WORK ORDER (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID) |
| FACT WORK ORDER (Dim_Project_ID) - PROJECT (ID) |
| FACT WORK ORDER (Dim_Reporting_Date_ID) - REPORTING DATE (ID) |
| FACT WORK ORDER (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID) |
| FACT WORK ORDER (DIM_SITE_ID) - SITE (ID) |
| FACT WORK ORDER (Dim_Sla_Order_No) - SLA ORDER (ID) |
| FACT WORK ORDER (Dim_Sub_Project_ID) - SUB PROJECT (ID) |
| FACT WORK ORDER (Dim_Supplier_ID) - SUPPLIER (ID) |
| FACT WORK ORDER (Dim_Symptom_ID) - SYMPTOM (ID) |
| FACT WORK ORDER (Dim_Vim_Serial_ID) - VIM SERIAL (ID) |
| FACT WORK ORDER (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID) |
| FACT WORK ORDER (DIM_WORK_ORDER_ID) - WORK ORDER (ID) |
| FACT WORK ORDER (DIM_WORK_TYPE_CATEGORY_ID) - WORK TYPE CATEGORY (ID) |
| FACT WORK ORDER (DIM_WORK_TYPE_ID) - WORK TYPE (ID) |
| FACT WORK TASK (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID) |
| FACT WORK TASK (Dim_Activity_ID) - ACTIVITY (ID) |
| FACT WORK TASK (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID) |
| FACT WORK TASK (Dim_Cause_ID) - CAUSE (ID) |
| FACT WORK TASK (Dim_Class_ID) - CLASS (ID) |
| FACT WORK TASK (Dim_Company_ID) - COMPANY (ID) |
| FACT WORK TASK (Dim_Customer_ID) - CUSTOMER (ID) |
| FACT WORK TASK (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID) |
| FACT WORK TASK (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID) |
| FACT WORK TASK (Dim_Date_Reported_ID) - REPORTING DATE (ID) |
| FACT WORK TASK (Dim_Discovery_ID) - DISCOVERY (ID) |
| FACT WORK TASK (Dim_Event_ID) - EVENT (ID) |
| FACT WORK TASK (Dim_Failing_Component_ID) - FAILING COMPONENT (ID) |
| FACT WORK TASK (Dim_Fault_Type_ID) - FAULT TYPE (ID) |
| FACT WORK TASK (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID) |
| FACT WORK TASK (Dim_Item_Class_ID) - ITEM CLASS (ID) |
| FACT WORK TASK (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID) |
| FACT WORK TASK (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| FACT WORK TASK (Dim_Organization_ID) - ORGANIZATION (ID) |
| FACT WORK TASK (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID) |
| FACT WORK TASK (Dim_PM_Group_ID) - PM GROUP (ID) |
| FACT WORK TASK (Dim_Priority_ID) - PRIORITY (ID) |
| FACT WORK TASK (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID) |
| FACT WORK TASK (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID) |
| FACT WORK TASK (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID) |
| FACT WORK TASK (Dim_Site_ID) - SITE (ID) |
| FACT WORK TASK (Dim_Site_ID) - SOURCE SITE (ID) |
| FACT WORK TASK (Dim_SLA_ORDER_Line_ID) - SLA ORDER LINE (ID) |
| FACT WORK TASK (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID) |
| FACT WORK TASK (Dim_Supplier_ID) - SUPPLIER (ID) |
| FACT WORK TASK (Dim_Symptom_ID) - SYMPTOM (ID) |
| FACT WORK TASK (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID) |
| FACT WORK TASK (Dim_Work_Order_ID) - WORK ORDER (ID) |
| FACT WORK TASK (Dim_Work_Stage_ID) - WORK STAGE (ID) |
| FACT WORK TASK (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID) |
| FACT WORK TASK (Dim_Work_Type_ID) - WORK TYPE (ID) |
| WO BUDGET (Dim_Activity_ID) - ACTIVITY (ID) |
| WO BUDGET (Dim_Company_ID) - COMPANY (ID) |
| WO BUDGET (Dim_Compatible_Unit_ID) - COMPATIBLE UNIT (ID) |
| WO BUDGET (Dim_Cost_Type_ID) - WO COST TYPE (ID) |
| WO BUDGET (Dim_Customer_ID) - CUSTOMER (ID) |
| WO BUDGET (Dim_Date_Earliest_Start_ID) - REQUIRED START DATE (ID) |
| WO BUDGET (Dim_Date_Required_Compl_ID) - REQUIRED FINISH DATE (ID) |
| WO BUDGET (Dim_Discovery_ID) - DISCOVERY (ID) |
| WO BUDGET (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID) |
| WO BUDGET (Dim_Linear_Asset_ID) - LINEAR ASSET (ID) |
| WO BUDGET (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| WO BUDGET (Dim_Organization_ID) - ORGANIZATION (ID) |
| WO BUDGET (Dim_Priority_ID) - PRIORITY (ID) |
| WO BUDGET (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID) |
| WO BUDGET (Dim_Project_ID) - PROJECT (ID) |
| WO BUDGET (Dim_Reporting_Date_ID) - REPORTING DATE (ID) |
| WO BUDGET (Dim_Site_ID) - SITE (ID) |
| WO BUDGET (Dim_Sub_Project_ID) - SUB PROJECT (ID) |
| WO BUDGET (Dim_Supplier_ID) - SUPPLIER (ID) |
| WO BUDGET (Dim_Symptom_ID) - SYMPTOM (ID) |
| WO BUDGET (Dim_Vim_Serial_ID) - VIM SERIAL (ID) |
| WO BUDGET (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID) |
| WO BUDGET (Dim_Work_Order_ID) - WORK ORDER (ID) |
| WO BUDGET (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID) |
| WO BUDGET (Dim_Work_Type_ID) - WORK TYPE (ID) |
| WORK TASK ACTUALS COST (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID) |
| WORK TASK ACTUALS COST (Dim_Activity_ID) - ACTIVITY (ID) |
| WORK TASK ACTUALS COST (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID) |
| WORK TASK ACTUALS COST (Dim_Cause_ID) - CAUSE (ID) |
| WORK TASK ACTUALS COST (Dim_Class_ID) - CLASS (ID) |
| WORK TASK ACTUALS COST (Dim_Company_ID) - COMPANY (ID) |
| WORK TASK ACTUALS COST (Dim_Customer_ID) - CUSTOMER (ID) |
| WORK TASK ACTUALS COST (Dim_Date_Actual_Compl_ID) - ACTUAL FINISH DATE (ID) |
| WORK TASK ACTUALS COST (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID) |
| WORK TASK ACTUALS COST (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID) |
| WORK TASK ACTUALS COST (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID) |
| WORK TASK ACTUALS COST (Dim_Date_Reported_ID) - REPORTING DATE (ID) |
| WORK TASK ACTUALS COST (Dim_Discovery_ID) - DISCOVERY (ID) |
| WORK TASK ACTUALS COST (Dim_Event_ID) - EVENT (ID) |
| WORK TASK ACTUALS COST (Dim_Failing_Component_ID) - FAILING COMPONENT (ID) |
| WORK TASK ACTUALS COST (Dim_Fault_Type_ID) - FAULT TYPE (ID) |
| WORK TASK ACTUALS COST (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID) |
| WORK TASK ACTUALS COST (Dim_Item_Class_ID) - ITEM CLASS (ID) |
| WORK TASK ACTUALS COST (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID) |
| WORK TASK ACTUALS COST (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| WORK TASK ACTUALS COST (Dim_Organization_ID) - ORGANIZATION (ID) |
| WORK TASK ACTUALS COST (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID) |
| WORK TASK ACTUALS COST (Dim_PM_Group_ID) - PM GROUP (ID) |
| WORK TASK ACTUALS COST (Dim_Priority_ID) - PRIORITY (ID) |
| WORK TASK ACTUALS COST (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID) |
| WORK TASK ACTUALS COST (Dim_Project_ID) - PROJECT (ID) |
| WORK TASK ACTUALS COST (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID) |
| WORK TASK ACTUALS COST (Dim_Service_Contract_Line_ID) - SERVICE CONTRACT (ID) |
| WORK TASK ACTUALS COST (Dim_Site_ID) - SITE (ID) |
| WORK TASK ACTUALS COST (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID) |
| WORK TASK ACTUALS COST (Dim_Source_Object_ID) - SOURCE OBJECT (ID) |
| WORK TASK ACTUALS COST (Dim_Sub_Project_ID) - SUB PROJECT (ID) |
| WORK TASK ACTUALS COST (Dim_Supplier_ID) - SUPPLIER (ID) |
| WORK TASK ACTUALS COST (Dim_Symptom_ID) - SYMPTOM (ID) |
| WORK TASK ACTUALS COST (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID) |
| WORK TASK ACTUALS COST (Dim_Work_Order_ID) - WORK ORDER (ID) |
| WORK TASK ACTUALS COST (Dim_Work_Stage_ID) - WORK STAGE (ID) |
| WORK TASK ACTUALS COST (Dim_Work_Task_ID) - WORK TASK (ID) |
| WORK TASK ACTUALS COST (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID) |
| WORK TASK ACTUALS COST (Dim_Work_Type_ID) - WORK TYPE (ID) |
| WORK TASK ACTUALS SALES (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID) |
| WORK TASK ACTUALS SALES (Dim_Act_Equipment_Object_ID) - REPORTED EQUIPMENT OBJECT (ID) |
| WORK TASK ACTUALS SALES (Dim_Activity_ID) - ACTIVITY (ID) |
| WORK TASK ACTUALS SALES (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID) |
| WORK TASK ACTUALS SALES (Dim_Cause_ID) - CAUSE (ID) |
| WORK TASK ACTUALS SALES (Dim_Class_ID) - CLASS (ID) |
| WORK TASK ACTUALS SALES (Dim_Company_ID) - COMPANY (ID) |
| WORK TASK ACTUALS SALES (Dim_Customer_ID) - CUSTOMER (ID) |
| WORK TASK ACTUALS SALES (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID) |
| WORK TASK ACTUALS SALES (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID) |
| WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - REPORTING DATE (ID) |
| WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - SLA LATEST FINISH DATE (ID) |
| WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - SLA LATEST START DATE (ID) |
| WORK TASK ACTUALS SALES (Dim_Discovery_ID) - DISCOVERY (ID) |
| WORK TASK ACTUALS SALES (Dim_Event_ID) - EVENT (ID) |
| WORK TASK ACTUALS SALES (Dim_Failing_Component_ID) - FAILING COMPONENT (ID) |
| WORK TASK ACTUALS SALES (Dim_Fault_Type_ID) - FAULT TYPE (ID) |
| WORK TASK ACTUALS SALES (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID) |
| WORK TASK ACTUALS SALES (Dim_Item_Class_ID) - ITEM CLASS (ID) |
| WORK TASK ACTUALS SALES (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID) |
| WORK TASK ACTUALS SALES (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| WORK TASK ACTUALS SALES (Dim_Organization_ID) - ORGANIZATION (ID) |
| WORK TASK ACTUALS SALES (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID) |
| WORK TASK ACTUALS SALES (Dim_PM_Group_ID) - PM GROUP (ID) |
| WORK TASK ACTUALS SALES (Dim_Priority_ID) - PRIORITY (ID) |
| WORK TASK ACTUALS SALES (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID) |
| WORK TASK ACTUALS SALES (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID) |
| WORK TASK ACTUALS SALES (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID) |
| WORK TASK ACTUALS SALES (Dim_Site_ID) - SITE (ID) |
| WORK TASK ACTUALS SALES (Dim_Site_ID) - SOURCE SITE (ID) |
| WORK TASK ACTUALS SALES (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID) |
| WORK TASK ACTUALS SALES (Dim_Source_Object_ID) - SOURCE OBJECT (ID) |
| WORK TASK ACTUALS SALES (Dim_Supplier_ID) - SUPPLIER (ID) |
| WORK TASK ACTUALS SALES (Dim_Symptom_ID) - SYMPTOM (ID) |
| WORK TASK ACTUALS SALES (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID) |
| WORK TASK ACTUALS SALES (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID) |
| WORK TASK ACTUALS SALES (Dim_Work_Order_ID) - WORK ORDER (ID) |
| WORK TASK ACTUALS SALES (Dim_Work_Stage_ID) - WORK STAGE (ID) |
| WORK TASK ACTUALS SALES (Dim_Work_Task_ID) - WORK TASK (ID) |
| WORK TASK ACTUALS SALES (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID) |
| WORK TASK ACTUALS SALES (Dim_Work_Type_ID) - WORK TYPE (ID) |
| WORK TASK PLANNED (Dim_Activity_ID) - ACTIVITY (ID) |
| WORK TASK PLANNED (Dim_Cause_ID) - CAUSE (ID) |
| WORK TASK PLANNED (Dim_Class_ID) - CLASS (ID) |
| WORK TASK PLANNED (Dim_Company_ID) - COMPANY (ID) |
| WORK TASK PLANNED (Dim_Cost_Type_ID) - WO COST TYPE (ID) |
| WORK TASK PLANNED (Dim_Customer_ID) - CUSTOMER (ID) |
| WORK TASK PLANNED (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID) |
| WORK TASK PLANNED (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID) |
| WORK TASK PLANNED (Dim_Discovery_ID) - DISCOVERY (ID) |
| WORK TASK PLANNED (Dim_Event_ID) - EVENT (ID) |
| WORK TASK PLANNED (Dim_Fault_Type_ID) - FAULT TYPE (ID) |
| WORK TASK PLANNED (Dim_Linear_Asset_ID) - LINEAR ASSET (ID) |
| WORK TASK PLANNED (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| WORK TASK PLANNED (Dim_Organization_ID) - ORGANIZATION (ID) |
| WORK TASK PLANNED (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID) |
| WORK TASK PLANNED (Dim_Priority_ID) - PRIORITY (ID) |
| WORK TASK PLANNED (Dim_Proj_Program_Id) - PROJECT PROGRAM (ID) |
| WORK TASK PLANNED (Dim_Reporting_Date_ID) - REPORTING DATE (ID) |
| WORK TASK PLANNED (Dim_Site_ID) - SITE (ID) |
| WORK TASK PLANNED (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID) |
| WORK TASK PLANNED (Dim_Sub_Project_ID) - SUB PROJECT (ID) |
| WORK TASK PLANNED (Dim_Supplier_ID) - SUPPLIER (ID) |
| WORK TASK PLANNED (Dim_Symptom_ID) - SYMPTOM (ID) |
| WORK TASK PLANNED (Dim_Vim_Serial_ID) - VIM SERIAL (ID) |
| WORK TASK PLANNED (Dim_Work_Order_ID) - WORK ORDER (ID) |
| WORK TASK PLANNED (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID) |
| WORK TASK PLANNED (Dim_Work_Type_ID) - WORK TYPE (ID) |
| WORK TASK POSTINGS (Dim_Account_ID) - ACCOUNT (ID) |
| WORK TASK POSTINGS (Dim_Activity_ID) - ACTIVITY (ID) |
| WORK TASK POSTINGS (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID) |
| WORK TASK POSTINGS (Dim_Cause_ID) - CAUSE (ID) |
| WORK TASK POSTINGS (Dim_Class_ID) - CLASS (ID) |
| WORK TASK POSTINGS (Dim_Code_B_ID) - CODE B (ID) |
| WORK TASK POSTINGS (Dim_Code_C_ID) - CODE C (ID) |
| WORK TASK POSTINGS (Dim_Code_D_ID) - CODE D (ID) |
| WORK TASK POSTINGS (Dim_Code_E_ID) - CODE E (ID) |
| WORK TASK POSTINGS (Dim_Code_F_ID) - CODE F (ID) |
| WORK TASK POSTINGS (Dim_Code_G_ID) - CODE G (ID) |
| WORK TASK POSTINGS (Dim_Code_H_ID) - CODE H (ID) |
| WORK TASK POSTINGS (Dim_Code_I_ID) - CODE I (ID) |
| WORK TASK POSTINGS (Dim_Code_J_ID) - CODE J (ID) |
| WORK TASK POSTINGS (Dim_Company_ID) - COMPANY (ID) |
| WORK TASK POSTINGS (Dim_Customer_ID) - CUSTOMER (ID) |
| WORK TASK POSTINGS (Dim_Date_Actual_Compl_ID) - ACTUAL FINISH DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_Earliest_Start_ID) - REQUIRED START DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_Latest_Finish_ID) - REQUIRED FINISH DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_SLA_Latest_Finish_ID) - SLA LATEST FINISH DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_SLA_Latest_Start_Id) - SLA LATEST START DATE (ID) |
| WORK TASK POSTINGS (Dim_Discovery_ID) - DISCOVERY (ID) |
| WORK TASK POSTINGS (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID) |
| WORK TASK POSTINGS (Dim_Event_ID) - EVENT (ID) |
| WORK TASK POSTINGS (Dim_Failing_Component_ID) - FAILING COMPONENT (ID) |
| WORK TASK POSTINGS (Dim_Fault_Type_ID) - FAULT TYPE (ID) |
| WORK TASK POSTINGS (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID) |
| WORK TASK POSTINGS (Dim_Item_Class_ID) - ITEM CLASS (ID) |
| WORK TASK POSTINGS (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID) |
| WORK TASK POSTINGS (Dim_Item_Class_Source_ID) - SOURCE CONNECTION (ID) |
| WORK TASK POSTINGS (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| WORK TASK POSTINGS (Dim_Organisation_Site_ID) - ORGANIZATION SITE (ID) |
| WORK TASK POSTINGS (Dim_Organization_ID) - ORGANIZATION (ID) |
| WORK TASK POSTINGS (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID) |
| WORK TASK POSTINGS (Dim_PM_Group_ID) - PM GROUP (ID) |
| WORK TASK POSTINGS (Dim_Posting_Type_ID) - TASK ACCOUNTING TYPE (ID) |
| WORK TASK POSTINGS (Dim_Priority_ID) - PRIORITY (ID) |
| WORK TASK POSTINGS (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID) |
| WORK TASK POSTINGS (Dim_Project_ID) - PROJECT (ID) |
| WORK TASK POSTINGS (Dim_Rep_Mch_Ref_ID) - REPORTED EQUIPMENT OBJECT (ID) |
| WORK TASK POSTINGS (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID) |
| WORK TASK POSTINGS (Dim_Reporting_Date_Id) - REPORTING DATE (ID) |
| WORK TASK POSTINGS (Dim_Rpd_Company_Period_ID) - REPORTING PERIOD (Company-Date) |
| WORK TASK POSTINGS (Dim_Service_Contract_Line_ID) - SERVICE CONTRACT (ID) |
| WORK TASK POSTINGS (Dim_Site_ID) - SITE (ID) |
| WORK TASK POSTINGS (Dim_Source_Object_ID) - SOURCE OBJECT (ID) |
| WORK TASK POSTINGS (Dim_Source_Site_ID) - SOURCE SITE (ID) |
| WORK TASK POSTINGS (Dim_Sub_Project_ID) - SUB PROJECT (ID) |
| WORK TASK POSTINGS (Dim_Supplier_ID) - SUPPLIER (ID) |
| WORK TASK POSTINGS (Dim_Symptom_ID) - SYMPTOM (ID) |
| WORK TASK POSTINGS (Dim_Time_Type_ID) - TIME TYPE (ID) |
| WORK TASK POSTINGS (Dim_Transaction_Type_ID) - TRANSACTION TYPE (ID) |
| WORK TASK POSTINGS (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID) |
| WORK TASK POSTINGS (Dim_WO_Cost_Type_ID) - WO COST TYPE (ID) |
| WORK TASK POSTINGS (Dim_Work_Order_No_Id) - WORK ORDER (ID) |
| WORK TASK POSTINGS (Dim_Work_Stage_ID) - WORK STAGE (ID) |
| WORK TASK POSTINGS (Dim_Work_Task_Seq_ID) - WORK TASK (ID) |
| WORK TASK POSTINGS (Dim_Work_Type_Cat_ID) - WORK TYPE CATEGORY (ID) |
| WORK TASK POSTINGS (Dim_Work_Type_ID) - WORK TYPE (ID) |
| WORK TASK PLANNED (Dim_Criticality_ID) - CRITICALITY (ID) |
| ASSET HEALTH LEVEL (レベル) - COLOR LEVEL (説明) |
| ASSET HEALTH (資産健全性レベル) - COLOR LEVEL (説明) |
| ASSET HEALTH (Dim_Company_Id) - COMPANY (ID) |
| ASSET HEALTH (Dim_Site_Id) - SITE (ID) |
| WORK TASK ACTUALS COST (Dim_Site_ID) - ACTUAL OBJECT SITE (ID) |
| WORK TASK ACTUALS SALES (Dim_Site_ID) - ACTUAL OBJECT SITE (ID) |
| WORK TASK POSTINGS (Dim_Actual_Obj_Site_ID) - ACTUAL OBJECT SITE (ID) |
| ASSET HEALTH INDI HST (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID) |
| ASSET HEALTH (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID) |
| ASSET HEALTH HISTORY (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID) |
| ASSET HEALTH LEVEL (Dim_Asset_Type) - ASSET TYPE (ID) |
| ASSET HEALTH (Dim_Asset_Type) - ASSET TYPE (ID) |
| ASSET HEALTH INDICATOR (Dim_Asset_Type) - ASSET TYPE (ID) |
| ASSET HEALTH HISTORY (Dim_Asset_Type) - ASSET TYPE (ID) |
| ASSET HEALTH INDI HST (Dim_Asset_Health_Indicator) - ASSET HEALTH INDICATOR DIMENSION (ID) |
| ASSET HEALTH INDICATOR (ID) - ASSET HEALTH INDICATOR DIMENSION (ID) |
| ASSET HEALTH INDI HST (Dim_Asset_Type) - ASSET TYPE (ID) |
| 場所(ID) - ASSET HEALTH (Dim_Asset_Id) |